Excel: count nonblank column numbers using COUNTA 使用COUNTA计算Excel非空行数

Categories: Development Notes; Tagged with: Excel; @ September 19th, 2012 19:16

Use COUNTA function:
Counts the number of cells that are not empty and the values within the list of arguments. Use COUNTA to count the number of cells that contain data in a range or array.

>>COUNTA function Details<<

Kindle电子书共享利器-Google Doc: 直接发送电子书到Kindle <-> 新加坡爬山: 武吉知马 Bukit Timah Summit

---

ActionScript Adobe AIR ANT Apache ApacheFlex Apache Flex Better Developer BlazeDS Cloud Computing CMD DataGrid DataGridColumn DB2 Derby DTSX Eclipse ETL Event Excel Flash Builder Flex Google Java JDBC JDK JIRA Life@SG|新加坡 Linux MySQL Oracle PHP Python RegEx Servlet SQL SQL Server SSIS SVN T-SQL Tools Tree Ugly WordPress XML dev-notes side-projects